package com.loongtech.bi.manager.game;

import com.loongtech.bi.entity.game.EntityMallStatistics10LevelNoParam;
import com.loongtech.core.jpa.manager.ManagerQueryCacheBase;
import org.springframework.stereotype.Service;

import java.util.List;
/*
 * 10等级 商城统计
 */
@Service
public class MallStatistics10LevelNoParamManager extends ManagerQueryCacheBase<EntityMallStatistics10LevelNoParam> {
	private static final long serialVersionUID = 1L;
	
	public List<Object[]> getMallStatistics10LevelByAllKind(String date, String queryPlatform, String queryChannel, String queryServer,String currencytype,Integer rolelevel) {
		return findByQuery("select sumchangenum,rolenum from EntityMallStatistics10LevelNoParam  where 1=1 and rolelevel = "+rolelevel+" and day= '"+date+"' and currencytype in "+ currencytype +" and platformid = '"+queryPlatform+"' and serverid = '"+queryServer+"' and channelid = '"+queryChannel+"'");
	}

    public List<Object[]> getMallStatistics10LevelByAllKind(String date, String queryPlatform, String queryChannel, String queryServer,String currencytype,Integer rolelevel, String reason) {
        return findByQuery("select sumchangenum,rolenum from EntityMallStatistics10LevelNoParam  where 1=1 and rolelevel = "+rolelevel+" and day= '"+date+"' and currencytype in "+ currencytype +" and platformid = '"+queryPlatform+"' and serverid = '"+queryServer+"' and channelid = '"+queryChannel+"'");
    }
}
